﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SQLite;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ZeroBug.PersonalityEvaluation
{
    public interface IDatabase
    {
        void SetDatabasePath(string path);
        DataTable GetTableStatus();
        void CreateTable(string tableName, List<SQLiteColumn> columns);
        void InsertOneRecord(string tableName, Dictionary<string, object> data);
        void UpdateOneRecord(string tableName, Dictionary<string, object> data, Dictionary<string, object> cond);
        DataTable Select(string sql, out string errInfo);
    }
}
